﻿CREATE TABLE [dbo].[Photograph] (
    [Id]       UNIQUEIDENTIFIER NOT NULL,
    [Caption]  NVARCHAR (50)    NULL,
    [Url]      NVARCHAR (2048)  NULL,
    [CreateAt] DATETIME2 (3)    NOT NULL,
    [Audit]    INT              NULL,
    [AlbumId]  UNIQUEIDENTIFIER NULL,
    CONSTRAINT [PK_Photograph] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Photograph_Album] FOREIGN KEY ([AlbumId]) REFERENCES [dbo].[Album] ([Id])
);









